Pandas Profiling Report

Dataset statistics

Number of variables	70
Number of observations	26648
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.3 MiB
Average record size in memory	171.0 B

Variable types

BOOL	55
CAT	8
NUM	7

Warnings

`flight_code` has a high cardinality: 1313 distinct values	High cardinality
`arrival_time` has a high cardinality: 906 distinct values	High cardinality
`departure_time_day` is highly correlated with `departure_time` and 1 other fields	High correlation
`departure_time` is highly correlated with `departure_time_day`	High correlation
`departure_date` is highly correlated with `departure_time_day`	High correlation
`number_of_stops` has 5301 (19.9%) zeros	Zeros
`departure_day` has 6957 (26.1%) zeros	Zeros
`booking_day` has 3776 (14.2%) zeros	Zeros

Reproduction

Analysis started	2020-10-07 12:45:31.860970
Analysis finished	2020-10-07 12:46:31.231637
Duration	59.37 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

Distinct	5730
Distinct (%)	21.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2387.683166
Minimum	0
Maximum	5783
Zeros	7
Zeros (%)	< 0.1%
Memory size	208.2 KiB

Quantile statistics

Minimum	0
5-th percentile	230
Q1	1147
median	2284.5
Q3	3431
95-th percentile	5120
Maximum	5783
Range	5783
Interquartile range (IQR)	2284

Descriptive statistics

Standard deviation	1487.008623
Coefficient of variation (CV)	0.622783058
Kurtosis	-0.8135551969
Mean	2387.683166
Median Absolute Deviation (MAD)	1141.5
Skewness	0.3230022456
Sum	63626981
Variance	2211194.646
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2023	7	< 0.1%
3321	7	< 0.1%
2552	7	< 0.1%
505	7	< 0.1%
537	7	< 0.1%
2616	7	< 0.1%
2632	7	< 0.1%
585	7	< 0.1%
601	7	< 0.1%
713	7	< 0.1%
Other values (5720)	26578	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	< 0.1%
1	7	< 0.1%
2	7	< 0.1%
3	7	< 0.1%
4	7	< 0.1%

Value	Count	Frequency (%)
5783	1	< 0.1%
5782	1	< 0.1%
5781	1	< 0.1%
5780	1	< 0.1%
5779	1	< 0.1%

Air India
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22751
1	3897

Common Values
Chart

Value	Count	Frequency (%)
0	22751	85.4%
1	3897	14.6%

AirAsia
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	24976
1	1672

Common Values
Chart

Value	Count	Frequency (%)
0	24976	93.7%
1	1672	6.3%

Go Air
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25297
1	1351

Common Values
Chart

Value	Count	Frequency (%)
0	25297	94.9%
1	1351	5.1%

IndiGo
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	16454
1	10194

Common Values
Chart

Value	Count	Frequency (%)
0	16454	61.7%
1	10194	38.3%

Spicejet
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	20817
1	5831

Common Values
Chart

Value	Count	Frequency (%)
0	20817	78.1%
1	5831	21.9%

Vistara
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22945
1	3703

Common Values
Chart

Value	Count	Frequency (%)
0	22945	86.1%
1	3703	13.9%

airline
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	208.2 KiB

IndiGo	10194
Spicejet	5831
Air India	3897
Vistara	3703
AirAsia	1672

Frequencies
Length

Value	Count	Frequency (%)
IndiGo	10194	38.3%
Spicejet	5831	21.9%
Air India	3897	14.6%
Vistara	3703	13.9%
AirAsia	1672	6.3%
Go Air	1351	5.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	9
Median length	7
Mean length	7.078054638
Min length	6

flight_code
Categorical

HIGH CARDINALITY

Distinct	1313
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Memory size	208.2 KiB

SG-789	168
UK-944 \| UK-813	56
SG-8152 \| SG-8705	56
SG-8152 \| SG-3724	56
6E-128	56
Other values (1308)	26256

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
SG-789	168	0.6%
UK-944 \| UK-813	56	0.2%
SG-8152 \| SG-8705	56	0.2%
SG-8152 \| SG-3724	56	0.2%
6E-128	56	0.2%
6E-6328 \| 6E-167	56	0.2%
6E-427 \| 6E-2405	56	0.2%
6E-6834 \| 6E-322	56	0.2%
AI-866	56	0.2%
6E-426 \| 6E-582	56	0.2%
Other values (1303)	25976	97.5%

Frequencies of value counts

Unique

Unique	128 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	37
Median length	15
Mean length	14.89969228
Min length	6

departure_time
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	208.2 KiB

morning	14568
afternoon	7556
evening	4106
night	418

Frequencies
Length

Value	Count	Frequency (%)
morning	14568	54.7%
afternoon	7556	28.4%
evening	4106	15.4%
night	418	1.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	9
Median length	7
Mean length	7.535725008
Min length	5

flight_duration
Real number (ℝ_≥0)

Distinct	274
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	494.9568448
Minimum	0
Maximum	1435
Zeros	40
Zeros (%)	0.2%
Memory size	208.2 KiB

Quantile statistics

Minimum	0
5-th percentile	115
Q1	205
median	425
Q3	715
95-th percentile	1135
Maximum	1435
Range	1435
Interquartile range (IQR)	510

Descriptive statistics

Standard deviation	324.9110891
Coefficient of variation (CV)	0.6564432688
Kurtosis	-0.08552123497
Mean	494.9568448
Median Absolute Deviation (MAD)	245
Skewness	0.7614929635
Sum	13189610
Variance	105567.2158
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
125	1061	4.0%
130	962	3.6%
135	865	3.2%
420	464	1.7%
165	464	1.7%
170	434	1.6%
330	428	1.6%
425	331	1.2%
410	311	1.2%
635	297	1.1%
Other values (264)	21031	78.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	40	0.2%
5	24	0.1%
10	53	0.2%
15	6	< 0.1%
20	26	0.1%

Value	Count	Frequency (%)
1435	14	0.1%
1430	55	0.2%
1425	9	< 0.1%
1405	26	0.1%
1400	62	0.2%

arrival_time
Categorical

HIGH CARDINALITY

Distinct	906
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Memory size	208.2 KiB

20:30	509
22:35	483
20:15	480
20:40	420
19:15	382
Other values (901)	24374

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
20:30	509	1.9%
22:35	483	1.8%
20:15	480	1.8%
20:40	420	1.6%
19:15	382	1.4%
20:50	339	1.3%
17:30	319	1.2%
22:45	290	1.1%
20:45	274	1.0%
18:20	273	1.0%
Other values (896)	22879	85.9%

Frequencies of value counts

Unique

Unique	57 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	41
Median length	5
Mean length	13.00682978
Min length	5

flight_cost
Real number (ℝ_≥0)

Distinct	1060
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5151.78974
Minimum	2540
Maximum	20674
Zeros	0
Zeros (%)	0.0%
Memory size	208.2 KiB

Quantile statistics

Minimum	2540
5-th percentile	3323
Q1	3797
median	4680
Q3	5910
95-th percentile	8731
Maximum	20674
Range	18134
Interquartile range (IQR)	2113

Descriptive statistics

Standard deviation	1869.544629
Coefficient of variation (CV)	0.3628922613
Kurtosis	5.198739453
Mean	5151.78974
Median Absolute Deviation (MAD)	883
Skewness	1.906065332
Sum	137284893
Variance	3495197.118
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3797	1770	6.6%
3746	1433	5.4%
3955	1232	4.6%
3481	1119	4.2%
3271	890	3.3%
5132	872	3.3%
4006	715	2.7%
4712	635	2.4%
3956	560	2.1%
4922	424	1.6%
Other values (1050)	16998	63.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2540	3	< 0.1%
2955	53	0.2%
2956	64	0.2%
2957	202	0.8%
3061	7	< 0.1%

Value	Count	Frequency (%)
20674	4	< 0.1%
20666	1	< 0.1%
18866	1	< 0.1%
18486	1	< 0.1%
18445	1	< 0.1%

number_of_stops
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.9828129691
Minimum	0
Maximum	5
Zeros	5301
Zeros (%)	19.9%
Memory size	208.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6768069427
Coefficient of variation (CV)	0.6886426654
Kurtosis	1.941358959
Mean	0.9828129691
Median Absolute Deviation (MAD)	0
Skewness	0.8233686836
Sum	26190
Variance	0.4580676376
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	17470	65.6%
0	5301	19.9%
2	2979	11.2%
3	831	3.1%
4	66	0.2%
5	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5301	19.9%
1	17470	65.6%
2	2979	11.2%
3	831	3.1%
4	66	0.2%

Value	Count	Frequency (%)
5	1	< 0.1%
4	66	0.2%
3	831	3.1%
2	2979	11.2%
1	17470	65.6%

departure_date
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	208.2 KiB

2020-10-12	3718
2020-10-11	3553
2020-10-07	3454
2020-10-09	3445
2020-10-10	3280
Other values (3)	9198

Frequencies
Length

Value	Count	Frequency (%)
2020-10-12	3718	14.0%
2020-10-11	3553	13.3%
2020-10-07	3454	13.0%
2020-10-09	3445	12.9%
2020-10-10	3280	12.3%
2020-10-05	3239	12.2%
2020-10-08	3133	11.8%
2020-10-06	2826	10.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

departure_day
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.650517863
Minimum	0
Maximum	6
Zeros	6957
Zeros (%)	26.1%
Memory size	104.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.145478968
Coefficient of variation (CV)	0.8094565212
Kurtosis	-1.3641934
Mean	2.650517863
Median Absolute Deviation (MAD)	2
Skewness	0.1575318788
Sum	70631
Variance	4.603080004
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	6957	26.1%
6	3553	13.3%
2	3454	13.0%
4	3445	12.9%
5	3280	12.3%
3	3133	11.8%
1	2826	10.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6957	26.1%
1	2826	10.6%
2	3454	13.0%
3	3133	11.8%
4	3445	12.9%

Value	Count	Frequency (%)
6	3553	13.3%
5	3280	12.3%
4	3445	12.9%
3	3133	11.8%
2	3454	13.0%

booking_date
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	208.2 KiB

2020-10-04	4054
2020-10-02	4044
2020-10-03	4037
2020-09-28	3776
2020-10-01	3705
Other values (2)	7032

Frequencies
Length

Value	Count	Frequency (%)
2020-10-04	4054	15.2%
2020-10-02	4044	15.2%
2020-10-03	4037	15.1%
2020-09-28	3776	14.2%
2020-10-01	3705	13.9%
2020-09-29	3518	13.2%
2020-09-30	3514	13.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

booking_day
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.090138097
Minimum	0
Maximum	6
Zeros	3776
Zeros (%)	14.2%
Memory size	208.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.013497147
Coefficient of variation (CV)	0.6515880793
Kurtosis	-1.256603876
Mean	3.090138097
Median Absolute Deviation (MAD)	2
Skewness	-0.07836505984
Sum	82346
Variance	4.054170762
Monotocity	Increasing

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
6	4054	15.2%
4	4044	15.2%
5	4037	15.1%
0	3776	14.2%
3	3705	13.9%
1	3518	13.2%
2	3514	13.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3776	14.2%
1	3518	13.2%
2	3514	13.2%
3	3705	13.9%
4	4044	15.2%

Value	Count	Frequency (%)
6	4054	15.2%
5	4037	15.1%
4	4044	15.2%
3	3705	13.9%
2	3514	13.2%

days_to_depart
Real number (ℝ_≥0)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.537038427
Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Memory size	208.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	8
Q3	10
95-th percentile	13
Maximum	14
Range	13
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.030074316
Coefficient of variation (CV)	0.402024528
Kurtosis	-0.6183467638
Mean	7.537038427
Median Absolute Deviation (MAD)	2
Skewness	-0.0108659168
Sum	200847
Variance	9.181350361
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
8	3437	12.9%
7	3350	12.6%
9	2899	10.9%
6	2714	10.2%
10	2460	9.2%
5	2376	8.9%
11	1888	7.1%
4	1860	7.0%
3	1446	5.4%
12	1406	5.3%
Other values (4)	2812	10.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	454	1.7%
2	907	3.4%
3	1446	5.4%
4	1860	7.0%
5	2376	8.9%

Value	Count	Frequency (%)
14	497	1.9%
13	954	3.6%
12	1406	5.3%
11	1888	7.1%
10	2460	9.2%

flight_path
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	208.2 KiB

Bengaluru-New Delhi	5780
Mumbai-New Delhi	5184
New Delhi-Mumbai	4535
Mumbai-Bengaluru	4360
New Delhi-Kolkata	4092
Other values (2)	2697

Frequencies
Length

Value	Count	Frequency (%)
Bengaluru-New Delhi	5780	21.7%
Mumbai-New Delhi	5184	19.5%
New Delhi-Mumbai	4535	17.0%
Mumbai-Bengaluru	4360	16.4%
New Delhi-Kolkata	4092	15.4%
New Delhi-Goa	2000	7.5%
Mumbai-Goa	697	2.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	19
Median length	16
Mean length	16.42217052
Min length	10

Bengaluru-New Delhi
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	20868
1	5780

Common Values
Chart

Value	Count	Frequency (%)
0	20868	78.3%
1	5780	21.7%

Mumbai-Bengaluru
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22288
1	4360

Common Values
Chart

Value	Count	Frequency (%)
0	22288	83.6%
1	4360	16.4%

Mumbai-Goa
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25951
1	697

Common Values
Chart

Value	Count	Frequency (%)
0	25951	97.4%
1	697	2.6%

Mumbai-New Delhi
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	21464
1	5184

Common Values
Chart

Value	Count	Frequency (%)
0	21464	80.5%
1	5184	19.5%

New Delhi-Goa
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	24648
1	2000

Common Values
Chart

Value	Count	Frequency (%)
0	24648	92.5%
1	2000	7.5%

New Delhi-Kolkata
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22556
1	4092

Common Values
Chart

Value	Count	Frequency (%)
0	22556	84.6%
1	4092	15.4%

New Delhi-Mumbai
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22113
1	4535

Common Values
Chart

Value	Count	Frequency (%)
0	22113	83.0%
1	4535	17.0%

bd__0
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22872
1	3776

Common Values
Chart

Value	Count	Frequency (%)
0	22872	85.8%
1	3776	14.2%

bd__1
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	23130
1	3518

Common Values
Chart

Value	Count	Frequency (%)
0	23130	86.8%
1	3518	13.2%

bd__2
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	23134
1	3514

Common Values
Chart

Value	Count	Frequency (%)
0	23134	86.8%
1	3514	13.2%

bd__3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22943
1	3705

Common Values
Chart

Value	Count	Frequency (%)
0	22943	86.1%
1	3705	13.9%

bd__4
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22604
1	4044

Common Values
Chart

Value	Count	Frequency (%)
0	22604	84.8%
1	4044	15.2%

bd__5
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22611
1	4037

Common Values
Chart

Value	Count	Frequency (%)
0	22611	84.9%
1	4037	15.1%

bd__6
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22594
1	4054

Common Values
Chart

Value	Count	Frequency (%)
0	22594	84.8%
1	4054	15.2%

dd__0
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	19691
1	6957

Common Values
Chart

Value	Count	Frequency (%)
0	19691	73.9%
1	6957	26.1%

dd__1
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	23822
1	2826

Common Values
Chart

Value	Count	Frequency (%)
0	23822	89.4%
1	2826	10.6%

dd__2
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	23194
1	3454

Common Values
Chart

Value	Count	Frequency (%)
0	23194	87.0%
1	3454	13.0%

dd__3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	23515
1	3133

Common Values
Chart

Value	Count	Frequency (%)
0	23515	88.2%
1	3133	11.8%

dd__4
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	23203
1	3445

Common Values
Chart

Value	Count	Frequency (%)
0	23203	87.1%
1	3445	12.9%

dd__5
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	23368
1	3280

Common Values
Chart

Value	Count	Frequency (%)
0	23368	87.7%
1	3280	12.3%

dd__6
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	23095
1	3553

Common Values
Chart

Value	Count	Frequency (%)
0	23095	86.7%
1	3553	13.3%

departure_time_day
Categorical

HIGH CORRELATION

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	208.2 KiB

morning-0	3903
morning-6	1935
afternoon-0	1934
morning-4	1884
morning-5	1828
Other values (23)	15164

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
morning-0	3903	14.6%
morning-6	1935	7.3%
afternoon-0	1934	7.3%
morning-4	1884	7.1%
morning-5	1828	6.9%
morning-2	1799	6.8%
morning-3	1686	6.3%
morning-1	1533	5.8%
afternoon-2	1069	4.0%
evening-0	1009	3.8%
Other values (18)	8068	30.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	11
Median length	9
Mean length	9.535725008
Min length	7

afternoon-0
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	24714
1	1934

Common Values
Chart

Value	Count	Frequency (%)
0	24714	92.7%
1	1934	7.3%

afternoon-1
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25879
1	769

Common Values
Chart

Value	Count	Frequency (%)
0	25879	97.1%
1	769	2.9%

afternoon-2
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25579
1	1069

Common Values
Chart

Value	Count	Frequency (%)
0	25579	96.0%
1	1069	4.0%

afternoon-3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25752
1	896

Common Values
Chart

Value	Count	Frequency (%)
0	25752	96.6%
1	896	3.4%

afternoon-4
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25686
1	962

Common Values
Chart

Value	Count	Frequency (%)
0	25686	96.4%
1	962	3.6%

afternoon-5
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25729
1	919

Common Values
Chart

Value	Count	Frequency (%)
0	25729	96.6%
1	919	3.4%

afternoon-6
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25641
1	1007

Common Values
Chart

Value	Count	Frequency (%)
0	25641	96.2%
1	1007	3.8%

evening-0
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25639
1	1009

Common Values
Chart

Value	Count	Frequency (%)
0	25639	96.2%
1	1009	3.8%

evening-1
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26177
1	471

Common Values
Chart

Value	Count	Frequency (%)
0	26177	98.2%
1	471	1.8%

evening-2
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26119
1	529

Common Values
Chart

Value	Count	Frequency (%)
0	26119	98.0%
1	529	2.0%

evening-3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26143
1	505

Common Values
Chart

Value	Count	Frequency (%)
0	26143	98.1%
1	505	1.9%

evening-4
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26098
1	550

Common Values
Chart

Value	Count	Frequency (%)
0	26098	97.9%
1	550	2.1%

evening-5
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26165
1	483

Common Values
Chart

Value	Count	Frequency (%)
0	26165	98.2%
1	483	1.8%

evening-6
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26089
1	559

Common Values
Chart

Value	Count	Frequency (%)
0	26089	97.9%
1	559	2.1%

morning-0
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	22745
1	3903

Common Values
Chart

Value	Count	Frequency (%)
0	22745	85.4%
1	3903	14.6%

morning-1
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	25115
1	1533

Common Values
Chart

Value	Count	Frequency (%)
0	25115	94.2%
1	1533	5.8%

morning-2
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	24849
1	1799

Common Values
Chart

Value	Count	Frequency (%)
0	24849	93.2%
1	1799	6.8%

morning-3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	24962
1	1686

Common Values
Chart

Value	Count	Frequency (%)
0	24962	93.7%
1	1686	6.3%

morning-4
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	24764
1	1884

Common Values
Chart

Value	Count	Frequency (%)
0	24764	92.9%
1	1884	7.1%

morning-5
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	24820
1	1828

Common Values
Chart

Value	Count	Frequency (%)
0	24820	93.1%
1	1828	6.9%

morning-6
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	24713
1	1935

Common Values
Chart

Value	Count	Frequency (%)
0	24713	92.7%
1	1935	7.3%

night-0
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26537
1	111

Common Values
Chart

Value	Count	Frequency (%)
0	26537	99.6%
1	111	0.4%

night-1
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26595
1	53

Common Values
Chart

Value	Count	Frequency (%)
0	26595	99.8%
1	53	0.2%

night-2
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26591
1	57

Common Values
Chart

Value	Count	Frequency (%)
0	26591	99.8%
1	57	0.2%

night-3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26602
1	46

Common Values
Chart

Value	Count	Frequency (%)
0	26602	99.8%
1	46	0.2%

night-4
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26599
1	49

Common Values
Chart

Value	Count	Frequency (%)
0	26599	99.8%
1	49	0.2%

night-5
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26598
1	50

Common Values
Chart

Value	Count	Frequency (%)
0	26598	99.8%
1	50	0.2%

night-6
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

0	26596
1	52

Common Values
Chart

Value	Count	Frequency (%)
0	26596	99.8%
1	52	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	df_index	AirAsia	Go Air	Spicejet	Vistara	airline	flight_code	departure_time	flight_duration	arrival_time	flight_cost	number_of_stops	departure_date	booking_date	days_to_depart	flight_path	Mumbai-New Delhi	bd__0	dd__0	departure_time_day	afternoon-0	evening-0	morning-0	night-0
0	0	1	0	0	0	AirAsia	I5-302 \| I5-741	morning	540.0	14:50	3500	1	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	morning-0	0	0	1	0
1	1	1	0	0	0	AirAsia	I5-317 \| I5-979	morning	660.0	21:45	3500	1	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	morning-0	0	0	1	0
2	2	1	0	0	0	AirAsia	I5-984 \| I5-741	night	860.0	13:45+1 DAYArrival : New Delhi06 Oct 2020	3868	1	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	night-0	0	0	0	1
3	3	0	1	0	0	Go Air	G8-306 \| G8-175	evening	760.0	10:30+1 DAYArrival : New Delhi06 Oct 2020	3500	1	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	evening-0	0	1	0	0
4	4	0	1	0	0	Go Air	G8-322	evening	125.0	23:40	3500	0	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	evening-0	0	1	0	0
5	5	0	1	0	0	Go Air	G8-327	morning	140.0	08:05	3868	0	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	morning-0	0	0	1	0
6	6	0	0	0	1	Vistara	UK-960	morning	125.0	13:20	3500	0	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	morning-0	0	0	1	0
7	7	0	0	0	1	Vistara	UK-944	afternoon	125.0	15:40	3500	0	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	afternoon-0	1	0	0	0
8	8	0	0	1	0	Spicejet	SG-790	afternoon	125.0	17:20	3868	0	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	afternoon-0	1	0	0	0
9	9	0	0	0	1	Vistara	UK-940	evening	125.0	21:45	3501	0	2020-10-05	2020-09-28	7	Mumbai-New Delhi	1	1	1	evening-0	0	1	0	0

Last rows

	df_index	Air India	IndiGo	Spicejet	Vistara	airline	flight_code	departure_time	flight_duration	arrival_time	flight_cost	number_of_stops	departure_date	booking_date	booking_day	days_to_depart	flight_path	New Delhi-Kolkata	bd__6	dd__0	departure_time_day	afternoon-0	evening-0	morning-0	night-0
26638	5773	1	0	0	0	Air India	AI-544 \| AI-525	afternoon	940.0	07:55+1 DAYArrival : Kolkata13 Oct 2020	9435	1	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	afternoon-0	1	0	0	0
26639	5774	0	0	1	0	Spicejet	SG-8169 \| SG-241	evening	760.0	08:30+1 DAYArrival : Kolkata13 Oct 2020	11687	1	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	evening-0	0	1	0	0
26640	5775	0	0	1	0	Spicejet	SG-8169 \| SG-487	evening	160.0	22:30+1 DAYArrival : Kolkata13 Oct 2020	4740	1	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	evening-0	0	1	0	0
26641	5777	0	1	0	0	IndiGo	6E-2192 \| 6E-6292	afternoon	370.0	20:15	9435	1	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	afternoon-0	1	0	0	0
26642	5778	0	1	0	0	IndiGo	6E-277 \| 6E-6292	morning	630.0	20:15	11687	1	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	morning-0	0	0	1	0
26643	5779	0	1	0	0	IndiGo	6E-251 \| 6E-349	morning	410.0	11:50	4740	1	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	morning-0	0	0	1	0
26644	5780	1	0	0	0	Air India	AI-504 \| AI-776	evening	780.0	10:40+1 DAYArrival : Kolkata13 Oct 2020	4740	1	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	evening-0	0	1	0	0
26645	5781	0	0	0	1	Vistara	UK-995 \| UK-775	morning	450.0	16:55	8912	1	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	morning-0	0	0	1	0
26646	5782	0	0	0	1	Vistara	UK-943 \| UK-775	morning	550.0	16:55	11176	1	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	morning-0	0	0	1	0
26647	5783	1	0	0	0	Air India	AI-851 \| AI-571 \| AI-525	night	190.0	07:55+1 DAYArrival : Kolkata13 Oct 2020	4740	3	2020-10-12	2020-10-04	6	8	New Delhi-Kolkata	1	1	1	night-0	0	0	0	1

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows